IT Data Engineer (experienced)
We are Farmers!
We are... more than just your favorite commercials. At Farmers, we strive to deliver peace of mind to our customers by providing protection and comprehensive advice and delivering in the moments of truth. That means having people who can help us meet changing customer and business needs. Farmers high-performance culture is focused on results and the people who achieve them. We hold ourselves and others accountable for sustainably growing the business and each other. We seek solutions, own our actions, and grow through discomfort. We see setbacks as opportunities while continuously asking ourselves how we impact our customers.
Farmers is an award winning, equal opportunity employer, committed to the strength of a diverse workforce. We are dedicated to supporting the well-being of our people through our extensive suite of benefits, as well as the well-being of the communities we serve through employee volunteer programs and nonprofit partnerships. Helping others in their time of need isn't just our business - it's our culture! To learn more about our high-performance culture and open opportunities, check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok.
Workplace: Hybrid ( #LI-Hybrid ), Remote ( #LI-Remote )
Farmers believes in a culture of collaboration, creativity, and innovation, which thrives when we have the ability to work flexibly in a virtual setting as well as the opportunity to be together in person. Our hybrid work environment combines the best of both worlds with at least three (3) days in office and up to two (2) days virtual for employees who live within fifty (50) miles of a Farmers corporate office. Applicants beyond fifty (50) miles may still be considered.
Job Summary
Responsible for acquiring, curating, and publishing data both on prem and in the cloud for analytical or operational uses for basic to moderate scenarios. Ensures the data is in a ready-to-use form that creates a single version of the truth across all data consumers, including business/technology users, reporting and visualization specialists and data scientists with coaching and support. Utilizes skills to translate business analytic requests/requirements into design, development, testing, deployment, and production maintenance tasks. Works with various technologies from big data, relational and non-relational databases, cloud environments, different programming languages and various reporting tools and is familiar with a few but requires training for some.
What You'll Do
• Consults independently, works iteratively, and is viewed as an expert on data projects of a complex nature. Ability to understand design requirement and existing business processes to lead in the design, development, and implementation of data products in partnership with business partners and data scientists.
• Produces complex data building blocks, data models, and data flows working with business partners and data scientists within personal lines and distribution domains to deliver requests such as dimensional data models, standard and ad hoc reporting, data feeds, dashboard reporting, ad hoc analysis, data profiling etc.
• Designs and manages highly complex projects while handling multiple complex cross-functional projects.
• Preps/cleanses data to optimize for downstream reporting using Farmers standards
• Functions as an expert in serving as a SME for appropriate data sources and for how best to operationalize solutions working closely with business partners and data scientists.
• Acts as a conduit between business and IT teams for all aspects of the work. Create Dimensional Data Models, STTM's and other technical documents for offshore developers and oversee technical delivery of projects by conducting code reviews, documentation reviews etc.
• Performs other duties as assigned.
What You'll Bring
• 3-5 years of related experience required.
Additional Qualification
• Possesses strong technical aptitude.
• Strong verbal communication and listening skills.
• Extensive experience interacting with senior leadership stakeholders around the topics of data access, quality, appropriate use, metric definitions and standardization.
• Effectively coaches junior members and delivers constructive feedback.
• Practical knowledge of SQL, Dimensional modeling, Query tuning, ETL orchestration ,PowerBI, Python
• Hands-on experience with multiple cloud platforms including AWS, Google, and Azure.
• Hand on experience with developing on SSIS and SSAS.
Education You'll Need
• High School Diploma or equivalent required.
• Bachelor's degree preferred.
Physical Actions
This role, whether performed virtually or in an office setting, will include normal and customary distractions, noise, and interruptions. Sits or stands for extended periods of time, up to a full work shift. Occasionally reaches overhead and below the knees, including bending, twisting, pulling, and stooping. Occasionally moves, lifts, carries, and places objects and supplies weighing 0-10 pounds without assistance. Listens to, interprets, and differentiates auditory information (example others speaking) at normal speaking levels with or without correction. Visually verifies and reads information. Visually locates material, resources and other objects. Ability to continuously operate a computer for extended periods of time, up to a full work shift. Physical dexterity sufficient to use hands, arms, and shoulders repetitively to operate keyboard and other office equipment up to a full work shift.
Benefits
• Farmers offers a competitive salary commensurate with experience, qualifications and location.
o CA Only: $103,920 - $165,770
o CO Only: $97,440 - $142,890
o HI Only: $97,440 - $152,900
o IL/MN/VT Only: $97,440 - $152,900
• o MD Only: $97,440 - $152,900
o NY/DC/Jersey City Only: $97,440 - $165,770
o Albany County: $103,920 - $142,890
o WA Only: $97,440 - $173,750
• Bonus Opportunity (based on Company and Individual Performance)
• 401(k)
• Medical
• Dental
• Vision
• Health Savings and Flexible Spending Accounts
• Life Insurance
• Paid Time Off
• Paid Parental Leave
• Tuition Assistance
• For more information, review "What we offer" on https://www.farmers.com/careers/corporate/#offer
Job Location(s): R_US - United States
Anticipated application deadline: At Farmers, the recruitment process is designed to ensure that we find the best talent to join our team. As part of this process, we typically close open positions within 8 to 21 days after posting. If you are interested in any of our open positions, we encourage you to submit your application promptly.
Farmers will consider for employment all qualified applicants, including those with criminal histories, in accordance with the Los Angeles Fair Chance Initiative for Hiring Ordinance or other applicable law. Pursuant to 18 U.S.C. Section 1033, Farmers is prohibited from employing any individual who has been convicted of any criminal felony involving dishonesty or a breach of trust without prior written consent from the state Department of Insurance.
Farmers is an Equal Opportunity Employer and does not discriminate in any employer/employee relations based on race, color, religion, gender, sexual orientation, gender expression, genetic information, national origin, age, disability, marital status, military and veteran's status, or any other basis protected by applicable discrimination laws.
Want to learn more about our culture & opportunities? Check out www.Farmers.com/careers/corporate and be sure to follow us on Instagram, LinkedIn, and TikTok.
